SQL User Mapping

In SQL Server Management Studio expand Security > Logins, select the Users (for example, ION) and then right-click ION and select Properties.

The Login Properties-ION window opens. Select User Mapping and in the Users mapped to this login section, select the appropriate Databases, User, and Default Schema based on the following:

Logins	Database	User	Default Schema	Role Membership
EPSS_DataCollector	ApplicationModule	EPSS_DataCollector	dbo	AMApplicationRole, public
	ION_Data	EPSS_DataCollector	dbo	Db_datacreader, EPSS, DataCollectorAccess, public
	ION_Network	EPSS_DataCollector	dbo	Db_datareader, public
AMUser	ApplicationModules	AMUser	Dbo	AMApplicationRole, public
ION	ION_Data	dbo	dbo	Db_owner, public
	ION_Network	dbo	dbo	Db_owner, public
	ION_SystemLog	dbo	dbo	Db_owner, public
ionedsd	ION_Data	ionedsd	dbo	ION_DSD_Reader, public
	ION_Network	ionedsd	dbo	NOM_DSD_Reader, public
Report	ION_Data	Report	dbo	db_datareader, ION_Reader, public

PME Segment Edition Note: For the EPSS Data Collector user, the mappings are available only for Data Center edition and Healthcare edition (not for PME installations). The screen below shows user mapping in SQL Server Management Studio.

Note: If a “user exists” message is observed during the user mapping process, contact Schneider Tech Support. They will probably have to delete the user from Security > Login > User(s).

You can also use the following query to see if there are issues with the “user exists” message:

ALTER AUTHORIZATION ON DATABASE::ION_Data TO ION;